SELECT	CONCAT(		'ALTER TABLE ',		table_name,		' RENAME TO 修改的表前缀_',		substring(table_name, 5),		';'	) sqlsFROM	information_schema.tables Where table_name LIKE '原来的表前缀_%';